﻿DROP TABLE IF EXISTS `open_catalog_p_no_goods`;
CREATE TABLE `open_catalog_p_no_goods` (
  `catalog_id` int(10) unsigned NOT NULL DEFAULT '0',
  `catalog_p_no` smallint(2) unsigned NOT NULL DEFAULT '0',
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`catalog_id`,`catalog_p_no`,`goods_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;